﻿CREATE TABLE [dbo].[TravelAuthorization] (
    [Id]                 UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [RefNumber]          NVARCHAR (50)    NOT NULL,
    [AuthorizationDate]  DATE             NOT NULL,
    [TravelerName]       NVARCHAR (250)   NOT NULL,
    [TravelerTitle]      NVARCHAR (250)   NOT NULL,
    [TravelPurpose]      NVARCHAR (MAX)   NOT NULL,
    [Destination]        NVARCHAR (250)   NOT NULL,
    [TravelStartDate]    DATE             NOT NULL,
    [TravelEndDate]      DATE             NOT NULL,
    [NoOfFlights]        INT              NULL,
    [FromLocation]       NVARCHAR (250)   NULL,
    [ToLocation]         NVARCHAR (250)   NULL,
    [ViaLocation]        NVARCHAR (250)   NULL,
    [TotalAmount]        MONEY            NULL,
    [Remarks]            NTEXT            NULL,
    [ProjectDonorId]     UNIQUEIDENTIFIER NULL,
    [PreparedBy]         UNIQUEIDENTIFIER NOT NULL,
    [ApprovedBy]         UNIQUEIDENTIFIER NULL,
    [AuthorizedBy]       UNIQUEIDENTIFIER NULL,
    [CountryProgrammeId] UNIQUEIDENTIFIER NULL
);

